SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].[usp_AddRecruitment]
	
	(
	@param_topic NVarChar(100),
	@param_contents text,
	@param_type NVarChar(50),
	@param_start_time smalldatetime,
	@param_end_time smalldatetime,
	@param_place NVarChar(50),
	@param_organisers NVarChar(50),
	@param_undertakingside NVarChar(50),
	@param_add_time smalldatetime,
	@param_user_add NVarChar(50),
	@param_state bit
	)
	
AS
	/* SET NOCOUNT ON */
	
	insert into dbo.JOL_Recruitment 
	(
	topic,
	contents,
	type,
	start_time,
	end_time,
	place,
	organisers,
	undertakingside,
	add_time,
	user_add,
	update_time,
	user_update,
	visit_times,
	state
	)
	values 
	(
	@param_topic,
	@param_contents,
	@param_type,
	@param_start_time,
	@param_end_time,
	@param_place,
	@param_organisers,
	@param_undertakingside,
	@param_add_time,
	@param_user_add,
	@param_add_time,
	@param_user_add,
	0,
	@param_state
	)

	RETURN

GO
